// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_SALES_FEE
// * CreateDate    : 2011/11/16 17:16:07
// * Creater       : CodeSmith
// * LastChangeDate: 2011/11/16 17:16:07
// * LastChanger   : 2011/11/16 17:16:07
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class SalesFeeTable : TableInfo
    {
		public const string C_TableName = "SALES_FEE";
		
		public const string C_SALES_FEE_ID = "SALES_FEE_ID";
		public const string C_CUSTOMER_ID = "CUSTOMER_ID";
		public const string C_RELATED_ID = "RELATED_ID";
		public const string C_FEE_CODE = "FEE_CODE";
		public const string C_FEE_TYPE = "FEE_TYPE";
		public const string C_PERSON_ID = "PERSON_ID";
		public const string C_FEE_START_DATE = "FEE_START_DATE";
		public const string C_FEE_END_DATE = "FEE_END_DATE";
		public const string C_ORDER_AMOUNT = "ORDER_AMOUNT";
		public const string C_SALES_AMOUNT = "SALES_AMOUNT";
		public const string C_ATTACHED_FILE = "ATTACHED_FILE";
		public const string C_APPROVED_BY = "APPROVED_BY";
		public const string C_APPROVED_DATE = "APPROVED_DATE";
		public const string C_APPROVED_AMOUNT = "APPROVED_AMOUNT";
		public const string C_APPROVE_REMARK = "APPROVE_REMARK";
		public const string C_CEO_APPROVED_BY = "CEO_APPROVED_BY";
		public const string C_CEO_APPROVED_DATE = "CEO_APPROVED_DATE";
		public const string C_CEO_APPROVED_REMARK = "CEO_APPROVED_REMARK";
		public const string C_CEO_APPROVED_AMOUNT = "CEO_APPROVED_AMOUNT";
		public const string C_USE_ADVANCE_AMOUNT = "USE_ADVANCE_AMOUNT";
		public const string C_CEO_APPROVED_SALES_FEE = "CEO_APPROVED_SALES_FEE";
		public const string C_EXPENSE_AMOUNT = "EXPENSE_AMOUNT";
		public const string C_FIN_PAID_DATE = "FIN_PAID_DATE";
		public const string C_FIN_PAYMENT_BY = "FIN_PAYMENT_BY";
		public const string C_FIN_PAID_AMOUNT = "FIN_PAID_AMOUNT";
        public const string C_FIN_PAYMENT_TYPE = "FIN_PAYMENT_TYPE";
        public const string C_FIN_ORDER_TYPE = "FIN_ORDER_TYPE";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
		public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
        public const string C_STATUS = "STATUS";
        public const string C_REMARK = "REMARK";
		
		public SalesFeeTable()
        {
            _tableName = "SALES_FEE";
        }
		
		protected static SalesFeeTable _current;
        public static SalesFeeTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new SalesFeeTable();

            _current.Add(C_SALES_FEE_ID, new ColumnInfo(C_SALES_FEE_ID,"SalesFeeId", true, typeof(string)));
            _current.Add(C_CUSTOMER_ID, new ColumnInfo(C_CUSTOMER_ID,"CustomerId", false, typeof(string)));
            _current.Add(C_RELATED_ID, new ColumnInfo(C_RELATED_ID,"RelatedId", false, typeof(string)));
            _current.Add(C_FEE_CODE, new ColumnInfo(C_FEE_CODE,"FeeCode", false, typeof(string)));
            _current.Add(C_FEE_TYPE, new ColumnInfo(C_FEE_TYPE,"FeeType", false, typeof(string)));
            _current.Add(C_PERSON_ID, new ColumnInfo(C_PERSON_ID,"PersonId", false, typeof(string)));
            _current.Add(C_FEE_START_DATE, new ColumnInfo(C_FEE_START_DATE,"FeeStartDate", false, typeof(DateTime)));
            _current.Add(C_FEE_END_DATE, new ColumnInfo(C_FEE_END_DATE,"FeeEndDate", false, typeof(DateTime)));
            _current.Add(C_ORDER_AMOUNT, new ColumnInfo(C_ORDER_AMOUNT,"OrderAmount", false, typeof(decimal)));
            _current.Add(C_SALES_AMOUNT, new ColumnInfo(C_SALES_AMOUNT,"SalesAmount", false, typeof(decimal)));
            _current.Add(C_ATTACHED_FILE, new ColumnInfo(C_ATTACHED_FILE,"AttachedFile", false, typeof(string)));
            _current.Add(C_APPROVED_BY, new ColumnInfo(C_APPROVED_BY,"ApprovedBy", false, typeof(string)));
            _current.Add(C_APPROVED_DATE, new ColumnInfo(C_APPROVED_DATE,"ApprovedDate", false, typeof(DateTime)));
            _current.Add(C_APPROVED_AMOUNT, new ColumnInfo(C_APPROVED_AMOUNT,"ApprovedAmount", false, typeof(decimal)));
            _current.Add(C_APPROVE_REMARK, new ColumnInfo(C_APPROVE_REMARK,"ApproveRemark", false, typeof(string)));
            _current.Add(C_CEO_APPROVED_BY, new ColumnInfo(C_CEO_APPROVED_BY,"CeoApprovedBy", false, typeof(string)));
            _current.Add(C_CEO_APPROVED_DATE, new ColumnInfo(C_CEO_APPROVED_DATE,"CeoApprovedDate", false, typeof(DateTime)));
            _current.Add(C_CEO_APPROVED_REMARK, new ColumnInfo(C_CEO_APPROVED_REMARK,"CeoApprovedRemark", false, typeof(string)));
            _current.Add(C_CEO_APPROVED_AMOUNT, new ColumnInfo(C_CEO_APPROVED_AMOUNT,"CeoApprovedAmount", false, typeof(decimal)));
            _current.Add(C_USE_ADVANCE_AMOUNT, new ColumnInfo(C_USE_ADVANCE_AMOUNT,"UseAdvanceAmount", false, typeof(decimal)));
            _current.Add(C_CEO_APPROVED_SALES_FEE, new ColumnInfo(C_CEO_APPROVED_SALES_FEE,"CeoApprovedSalesFee", false, typeof(decimal)));
            _current.Add(C_EXPENSE_AMOUNT, new ColumnInfo(C_EXPENSE_AMOUNT,"ExpenseAmount", false, typeof(decimal)));
            _current.Add(C_FIN_PAID_DATE, new ColumnInfo(C_FIN_PAID_DATE,"FinPaidDate", false, typeof(DateTime)));
            _current.Add(C_FIN_PAYMENT_BY, new ColumnInfo(C_FIN_PAYMENT_BY,"FinPaymentBy", false, typeof(string)));
            _current.Add(C_FIN_PAID_AMOUNT, new ColumnInfo(C_FIN_PAID_AMOUNT,"FinPaidAmount", false, typeof(decimal)));
            _current.Add(C_FIN_PAYMENT_TYPE, new ColumnInfo(C_FIN_PAYMENT_TYPE, "FinPaymentType", false, typeof(string)));
            _current.Add(C_FIN_ORDER_TYPE, new ColumnInfo(C_FIN_ORDER_TYPE, "FinOrderType", false, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE,"LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY,"LastModifiedBy", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK, "Remark", false, typeof(string)));
			
		}
		
		public ColumnInfo SALES_FEE_ID
        {
            get { return this[C_SALES_FEE_ID]; }
        }
		
		public ColumnInfo CUSTOMER_ID
        {
            get { return this[C_CUSTOMER_ID]; }
        }
		
		public ColumnInfo RELATED_ID
        {
            get { return this[C_RELATED_ID]; }
        }
		
		public ColumnInfo FEE_CODE
        {
            get { return this[C_FEE_CODE]; }
        }
		
		public ColumnInfo FEE_TYPE
        {
            get { return this[C_FEE_TYPE]; }
        }
		
		public ColumnInfo PERSON_ID
        {
            get { return this[C_PERSON_ID]; }
        }
		
		public ColumnInfo FEE_START_DATE
        {
            get { return this[C_FEE_START_DATE]; }
        }
		
		public ColumnInfo FEE_END_DATE
        {
            get { return this[C_FEE_END_DATE]; }
        }
		
		public ColumnInfo ORDER_AMOUNT
        {
            get { return this[C_ORDER_AMOUNT]; }
        }
		
		public ColumnInfo SALES_AMOUNT
        {
            get { return this[C_SALES_AMOUNT]; }
        }
		
		public ColumnInfo ATTACHED_FILE
        {
            get { return this[C_ATTACHED_FILE]; }
        }
		
		public ColumnInfo APPROVED_BY
        {
            get { return this[C_APPROVED_BY]; }
        }
		
		public ColumnInfo APPROVED_DATE
        {
            get { return this[C_APPROVED_DATE]; }
        }
		
		public ColumnInfo APPROVED_AMOUNT
        {
            get { return this[C_APPROVED_AMOUNT]; }
        }
		
		public ColumnInfo APPROVE_REMARK
        {
            get { return this[C_APPROVE_REMARK]; }
        }
		
		public ColumnInfo CEO_APPROVED_BY
        {
            get { return this[C_CEO_APPROVED_BY]; }
        }
		
		public ColumnInfo CEO_APPROVED_DATE
        {
            get { return this[C_CEO_APPROVED_DATE]; }
        }
		
		public ColumnInfo CEO_APPROVED_REMARK
        {
            get { return this[C_CEO_APPROVED_REMARK]; }
        }
		
		public ColumnInfo CEO_APPROVED_AMOUNT
        {
            get { return this[C_CEO_APPROVED_AMOUNT]; }
        }
		
		public ColumnInfo USE_ADVANCE_AMOUNT
        {
            get { return this[C_USE_ADVANCE_AMOUNT]; }
        }
		
		public ColumnInfo CEO_APPROVED_SALES_FEE
        {
            get { return this[C_CEO_APPROVED_SALES_FEE]; }
        }
		
		public ColumnInfo EXPENSE_AMOUNT
        {
            get { return this[C_EXPENSE_AMOUNT]; }
        }
		
		public ColumnInfo FIN_PAID_DATE
        {
            get { return this[C_FIN_PAID_DATE]; }
        }
		
		public ColumnInfo FIN_PAYMENT_BY
        {
            get { return this[C_FIN_PAYMENT_BY]; }
        }
		
		public ColumnInfo FIN_PAID_AMOUNT
        {
            get { return this[C_FIN_PAID_AMOUNT]; }
        }
		
		public ColumnInfo FIN_PAYMENT_TYPE
        {
            get { return this[C_FIN_PAYMENT_TYPE]; }
        }

        public ColumnInfo FIN_ORDER_TYPE
        {
            get { return this[C_FIN_ORDER_TYPE]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }
		
		public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
	}
}

